How to convert the Multiple select Query into Case Statement in Oracle

welcome to shbcf.ru